﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<显示被退回的信息>
-- =============================================
CREATE PROCEDURE [dbo].[proc_InOutSide_AuditViewItem]
(
	@id INT
)

AS
BEGIN

SELECT (SELECT c.CustomerName FROM Customer c WHERE c.CustomerId=InOutSide.CusId) AS CustomerName
       ,(SELECT TOP 1 e.EName FROM Employee e WHERE e.UserName=InOutSide.OutSide AND InOutSide.OutSide<>'') AS OutSideName
       ,*
FROM InOutSide 
WHERE id=@id

	SET NOCOUNT ON;


END